home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freelog Special Freeware 31
/
FreelogHS31.iso
/
ArgentCompta
/
FASTCOMPTA
/
Setup FASTCOMPTA.exe
/
{app}
/
Initbase.sql
< prev
next >
Wrap
Text File
|
2006-11-13
|
20KB
|
169 lines
SET GENERATOR GENPK_BLOBS TO 5;
INSERT INTO "TVA" ("INDX", "DESIGNATION", "VALEUR") VALUES (1, 'TVA α 19,60 %', 19.6);
INSERT INTO "TVA" ("INDX", "DESIGNATION", "VALEUR") VALUES (2, 'TVA rΘduite α 5,5 %', 5.5);
SET GENERATOR GENPK_TVA TO 2;
COMMIT;
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (1, '101000', 'CAPITAL', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (2, '119000', 'Report α nouveau (dΘbiteur)', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (3, '120000', 'RΘsultat de l''exercice (bΘnΘfice)', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (4, '129000', 'Report a nouveau', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (5, '218300', 'Immobilisation matΘriel du bureau', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (6, '218400', 'Mobilier', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (7, '281830', 'Amort. Mat. Bureau', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (8, '281840', 'Amort. Mobilier', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (9, '371000', 'Stock', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (10, '401000', 'Collectif Fournisseurs', NULL, NULL, 0, 7);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (11, '408100', 'Attente Fournisseurs', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (12, '411000', 'Clients', NULL, NULL, 0, 1);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (13, '416000', 'Clients douteux', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (14, '418000', 'Attente clients', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (15, '419100', 'Acomptes versΘs par clients', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (16, '421000', 'Salaires personnel', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (17, '428200', 'CongΘs payΘs', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (18, '431000', 'SΘcuritΘ sociale', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (19, '437003', 'Caisse de retraite non-cadres', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (20, '437004', 'Caisse de retraite', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (21, '437005', 'MΘdecine du Travail', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (22, '437010', 'Mutuelle', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (23, '444000', 'Imp⌠ts sur les bΘnΘfices', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (24, '445500', 'T.V.A α DΘcaisser', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (25, '445620', 'TVA sur immobilisations', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (26, '445660', 'T.V.A sur Achats (tous taux)', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (27, '445710', 'TVA sur Ventes', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (28, '445860', 'TVA sur FAR', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (29, '448600', 'Etat- Charges α payer', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (30, '455000', 'AssociΘs - Compte courant.', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (31, '467000', 'Notes de frais', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (32, '491000', 'Provision sur dΘprΘciation crΘances', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (33, '491600', 'Provision sur clients douteux', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (34, '512100', 'Banque 1', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (35, '512101', 'Banque 2', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (36, '530000', 'Caisse en Euros', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (37, '580000', 'Virement interne', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (38, '602250', 'Achat Fournitures', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (39, '603700', 'Variations Stock de marchandise', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (40, '603710', 'Stock', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (41, '606000', 'Fournitures diverses', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (42, '606300', 'Fournitures', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (43, '606400', 'Fournitures Administratives', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (44, '607000', 'Achat de marchandise', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (45, '607050', 'Achat Hors TVA', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (46, '613200', 'Locations Immobilieres', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (47, '615500', 'SUR BIEN IMMO', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (48, '616000', 'Prime d''assurance', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (49, '618300', 'Documentation technique', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (50, '622600', 'Honoraires', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (51, '623000', 'PublicitΘ, Publications', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (52, '624100', 'Transport sur Achat', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (53, '624200', 'Transport', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (54, '625100', 'Frais de dΘpalcement et de mission', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (55, '625101', 'PΘage (tva 19.6 %)', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (56, '626000', 'Frais postaux & tΘlΘcom', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (57, '626100', 'Frais Postaux et transport ventes', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (58, '626200', 'Frais de TΘlΘcommunication', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (59, '626300', 'ElectricitΘ', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (60, '627000', 'Comission 1 % Carte Bleu', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (61, '631200', 'Taxe d''apprentissage', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (62, '631300', 'Formation continue', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (63, '635100', 'Taxe professionnelle', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (64, '641100', 'Salaires BRUT', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (65, '641200', 'CongΘs payΘs', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (66, '641210', 'Primes α payer', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (67, '641800', 'IndemnitΘ licenciement', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (68, '645100', 'Cotisation URSAAF', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (69, '645200', 'Charges sociales sur C.P', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (70, '645210', 'Charges sur prime', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (71, '645300', 'Retraite', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (72, '645400', 'ASSEDIC', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (73, '647500', 'MΘdecine du Travail', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (74, '654000', 'ImpayΘs', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (75, '658000', 'Charges diverses Gestion courante', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (76, '661100', 'Agios', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (77, '661600', 'Agios Bancaires', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (78, '665000', 'Escompte accordΘ', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (79, '668800', 'Charges de conversion Euro', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (80, '671800', 'Compte de rΘgul', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (81, '675000', 'Actifs cΘdΘs ou HS', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (82, '681120', 'Dot amort', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (83, '681700', 'Dotation', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (84, '681740', 'Dotation pour provision crΘances', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (85, '695000', 'Imp⌠ts sociΘtΘ', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (86, '697000', 'IFA', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (87, '707000', 'Vente de marchandise', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (88, '707050', 'Vente EXPORT', NULL, NULL, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (89, '707070', 'Services et prestations', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (90, '758000', 'Produit Gestion courante', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (91, '765000', 'Escompte Fournisseur', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (92, '768800', 'Produits de conversion Euro', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (93, '770000', 'Produit exceptionnel', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (94, '771000', 'Produit divers', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (95, '781000', 'RΘgularisation du 491600', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (96, '781740', 'Provision comptes dΘbiteurs', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (97, '791000', 'Remboursement assurance', NULL, 1, 0, NULL);
INSERT INTO COMPTES (INDX, LIB_COURT, LIB_LONG, REGROUPEMENT, INDX_TVA, VERROU, CONTREPARTIE) VALUES (98, 'SOLDE', 'Clients soldΘs', 12, NULL, 0, 87);
SET GENERATOR GENPK_COMPTES TO 98;
COMMIT;
INSERT INTO "JOURNAL" ("INDX", "SHORTDESI", "LONGDESI", "TYPEJX", "NUMEROTATION", "INDX_COMPTE") VALUES (1, 'HA', 'Achats', 0, 2, 10);
INSERT INTO "JOURNAL" ("INDX", "SHORTDESI", "LONGDESI", "TYPEJX", "NUMEROTATION", "INDX_COMPTE") VALUES (2, 'VT', 'Ventes', 1, 2, 12);
INSERT INTO "JOURNAL" ("INDX", "SHORTDESI", "LONGDESI", "TYPEJX", "NUMEROTATION", "INDX_COMPTE") VALUES (3, 'BQ', 'Banque', 2, 0, 34);
INSERT INTO "JOURNAL" ("INDX", "SHORTDESI", "LONGDESI", "TYPEJX", "NUMEROTATION", "INDX_COMPTE") VALUES (4, 'AN', 'A Nouveaux', 4, 0, NULL);
INSERT INTO "JOURNAL" ("INDX", "SHORTDESI", "LONGDESI", "TYPEJX", "NUMEROTATION", "INDX_COMPTE") VALUES (5, 'OD', 'OpΘrations diverses', 3, 3, NULL);
INSERT INTO "JOURNAL" ("INDX", "SHORTDESI", "LONGDESI", "TYPEJX", "NUMEROTATION", "INDX_COMPTE") VALUES (6, 'CA', 'Caisse', 2, 2, 36);
SET GENERATOR GENPK_JOURNAL TO 6;
SET GENERATOR GENPK_TIERS TO 1;
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 1, 12);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 2, 36);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 3, 98);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 4, 27);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 5, 27);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 6, 87);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 7, 10);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 8, 36);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 9, 10);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 10, 26);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 11, 26);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (0, 12, 44);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (1, 1, 2);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (1, 2, 6);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (1, 3, 2);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (1, 4, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (1, 5, 6);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (1, 6, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 1, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 2, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 3, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 4, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 5, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 6, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 7, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 8, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 9, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 10, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 11, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 12, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 13, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 14, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 15, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 16, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 17, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 18, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 19, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 20, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 21, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 22, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 23, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 24, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 25, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 26, 1);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (2, 27, 0);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (20, 1960, 27);
INSERT INTO PREFERENCES (TYPEPREF, VALEUR, INDX) VALUES (21, 1960, 26);
COMMIT;